SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804498 LIMIT 1 [ RunTime:0.001490s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804498 [ RunTime:0.001442s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (293277,471195,196137,57265,83306,747142,126426,970910,501344,408752,999173,29700,763137,168273,425190,249737,644074,148107,417027,515930,983588,1038504,1039388,756873,890135,1021402,748105,400894,122082,791417,98731,487063,380271,618718,313406,558750,645677,264649,625411,351716,130982,557767,24255,1043718,495419,385328,513054,98273,917735,923114,652685,969323,892254,112986,667401,192568,36598,263830,102340,614293) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804498 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804498 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]