SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489538 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489538 [ RunTime:0.001588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (195085,352022,830512,439412,798964,686860,923210,10798,652960,302878,150145,535262,442533,109087,135098,866688,885941,455731,540216,828347,1013973,70913,1000761,862125,48761,43642,979677,116817,968788,388554,391569,947996,640167,93698,106989,625831,154329,106311,457712,8936,711260,975306,947130,1041280,181851,76771,295514,524961,677895,901733,899721,1036031,37536,370272,227473,503206,438554,527462,429558,301796) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489538 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489538 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]