SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3403 LIMIT 1 [ RunTime:0.000465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3403 [ RunTime:0.002256s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (475685,171224,946268,231844,623358,18296,647530,395861,426324,798798,582762,952840,919282,757567,343861,242987,726841,154250,983743,19839,90930,805727,604781,343667,953159,673296,986891,307876,125272,279752,709195,1046708,877365,904393,982070,281594,411672,107759,535436,848450,401741,671645,406676,909935,875744,442350,710803,482328,991318,191638,686170,1044423,1046874,944637,891759,321731,869254,525636,268333,951311) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000737s ]