SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 344875 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 344875 [ RunTime:0.001527s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41266,607829,408955,499762,95404,917768,676153,1907,673184,77955,450711,665396,603879,865905,508045,622249,233744,342889,375921,221562,309241,126656,312119,760999,161448,989692,648139,247361,425416,1009627,275183,396742,90714,810448,352133,843842,617809,47012,293582,993098,461930,698372,180673,168427,85006,768880,372661,732455,281721,496886,606870,784957,486335,510429,230450,363266,332810,588293,250386,56690) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000932s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 344875 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 344875 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]