SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510951 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510951 [ RunTime:0.002750s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (442227,1026105,416776,356622,139202,928227,1020904,295875,574418,1043225,863403,389093,552166,478158,675087,825401,537586,148414,650495,85915,255034,446616,704462,41270,963623,764749,584678,983710,721800,611075,684484,464838,255846,605717,65954,209817,441593,377343,322102,13504,814541,820747,135796,505895,388756,507505,277570,277627,819019,367174,935541,120992,349545,505311,137515,570499,886827,898719,38101,252359) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510951 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510951 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]