SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 460681 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 460681 [ RunTime:0.001724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (991044,706143,400262,846028,956232,740906,194485,420884,497158,729918,903526,318892,301341,42901,931591,686865,756791,465362,543952,673525,683290,242545,988403,253224,949958,437983,996552,1037556,819893,766102,280676,938431,104253,769,404487,69373,861504,1005462,336692,277379,387394,428949,429151,976131,805656,684911,703076,277682,689941,987918,901800,80601,116032,852171,788437,701596,824912,785799,565245,133383) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 460681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 460681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000681s ]