SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030323 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030323 [ RunTime:0.001689s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (684916,378220,990730,552682,1003418,761990,576244,587134,451511,564491,837621,120886,907742,780340,115641,315990,192887,580624,86708,268946,255620,586247,689044,354516,264802,354203,935839,819973,72306,199725,751472,19646,595720,900058,831373,601886,79968,781202,87539,415630,306220,232257,916336,551473,240632,778506,972425,844282,954394,443163,91034,143184,444453,111049,835767,488453,430971,637183,509794,85470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030323 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030323 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]