SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381845 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381845 [ RunTime:0.001988s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (579908,445606,162345,782036,154520,739093,603497,178771,787708,159003,542997,935751,375490,945393,55735,860927,68013,180094,125382,219951,791466,4825,926723,797601,291755,1012110,806344,577517,770156,249414,21135,828417,207317,767967,437109,545689,786798,628178,415515,774206,97256,9854,660286,324669,788318,1048778,785372,534187,425542,663867,895574,982253,539372,870730,1047445,557822,823290,254076,27287,207538) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001724s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381845 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381845 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]