SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000920s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583628 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583628 [ RunTime:0.004402s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (890926,471502,36858,553221,665636,1011157,126031,957974,146082,1005096,1013598,134748,236668,879911,517696,405818,1023526,613916,89058,444621,1557,82446,985115,990931,13828,589325,921843,794187,636564,936674,546263,653398,227119,706430,387008,388387,609845,844754,474210,256930,733120,505958,667902,735226,436413,485590,77432,849041,886588,167070,169791,452688,808247,44866,99483,379184,241957,21200,140641,763678) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]