SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003618s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 652611 LIMIT 1 [ RunTime:0.001629s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 652611 [ RunTime:0.004341s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1035297,192599,25705,514563,427666,958640,780504,289819,590999,880633,969981,132530,230489,618338,683511,426571,435764,190084,895685,778917,574722,826509,954271,187044,172280,819026,494532,405695,682940,249508,120581,406656,37774,554231,117939,414489,1241,170122,630377,162996,123296,497096,1037447,545646,30593,576567,365827,539120,87713,174685,468081,862500,605435,139192,445257,121304,393113,374759,930949,413377) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001759s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 652611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 652611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002495s ]