SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 629183 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 629183 [ RunTime:0.001831s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1045981,340305,500403,473072,593438,179667,373054,1006183,1034485,1033181,904491,633902,99569,132783,732048,417709,851690,732952,388203,417505,30524,648959,1012086,726229,163098,773044,170343,152616,468537,1007889,306178,19102,47804,162684,197280,278101,47819,485317,649903,951267,814535,422528,989766,259353,967942,899832,743893,143728,206657,626124,332007,1010987,562029,967347,894031,573679,111797,45297,652168,166700) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 629183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 629183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]