SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400514 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400514 [ RunTime:0.002250s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (846726,861187,876659,260652,66831,175821,47393,347518,439393,606687,997051,424445,237203,831291,132026,439391,1038819,38542,1024182,74678,725507,343696,749710,303872,559926,995092,824127,292592,735813,738145,76416,1015599,372317,504844,5323,29851,851059,700555,86918,807735,572727,664423,940593,953816,617840,566511,405996,614655,182029,463379,814435,773542,962806,859047,630794,357594,750045,855957,603417,172396) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000374s ]