SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 800423 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 800423 [ RunTime:0.003497s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (47993,519129,459396,80076,159185,357762,119190,265369,722993,368901,427491,883641,145316,165346,13146,957008,1046823,940029,383094,476693,662711,601720,175512,810512,655744,600935,900999,636176,249059,489667,747079,1032912,782843,212376,999176,1036520,395242,780541,37237,706297,543363,892226,602751,173885,315786,255330,94566,965945,268187,158693,84927,392274,751426,323950,603440,706847,1020687,185869,328605,53143) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 800423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 800423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]