SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 393853 LIMIT 1 [ RunTime:0.000470s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 393853 [ RunTime:0.005650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (537648,715530,540785,741899,80220,599932,292461,162521,215858,275848,315598,991555,407913,569568,154401,836154,410430,678739,671210,365345,52464,739762,108977,574078,699261,924498,553728,897665,343037,21510,85442,588632,391723,331625,564138,858413,468781,293834,425410,961047,823531,170806,1036777,88800,809964,392565,300184,590239,1022699,1033475,873402,493211,288671,503992,569932,725857,81519,839526,695026,818554) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 393853 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 393853 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]