SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001339s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031194 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031194 [ RunTime:0.003337s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (392205,324555,1040863,996610,636838,310693,393166,724588,385025,6018,703851,19356,582533,687392,223740,809184,205289,178491,965713,386731,159661,401754,1030480,1028178,300723,875215,633808,566313,1041167,862465,174053,905613,194751,131383,447335,610533,395522,323143,394195,674341,562654,174161,327979,895789,194215,451,819864,965420,129619,740487,967854,1042388,388653,1011195,581682,192257,1024921,1001398,650032,727634) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002761s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031194 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031194 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]