SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002521s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 394094 LIMIT 1 [ RunTime:0.001443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 394094 [ RunTime:0.004495s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (12687,813583,505306,838773,867087,814213,250125,246304,630637,585472,104752,804845,245472,457712,4737,26938,543045,920103,640398,973372,751713,351418,744973,898862,970226,901078,630486,1031627,231122,1047411,472027,273267,920899,550772,955872,909518,102452,708803,476057,612649,178511,521792,78494,735295,903751,310367,273295,1029849,195653,1031600,969471,824314,297338,397195,285247,251982,242063,443420,343104,557457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001626s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 394094 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001559s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 394094 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000683s ]