SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53008 LIMIT 1 [ RunTime:0.000287s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53008 [ RunTime:0.001550s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (550195,428977,242442,201889,446496,940515,905422,802134,617349,1038729,241783,817881,451885,208657,594776,23010,236176,106481,536557,965363,958538,335199,872904,129116,470905,592054,173097,539133,851562,510745,118179,405527,222551,281240,458805,1017909,880675,553730,790125,324474,948337,883355,497500,622091,414881,73250,107805,372389,880520,332870,133265,1030310,689662,753618,290950,463869,484449,323762,784750,203981) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]