SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 686038 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 686038 [ RunTime:0.001747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (60338,823902,60699,402716,871036,775317,501786,771688,310398,225156,1044293,318538,265024,456505,732665,443401,508222,85431,441243,807046,899000,1095,951369,60767,301380,359666,274582,336356,567494,1025198,15431,937322,571736,78132,1004508,373046,229606,539540,695031,218505,281437,211840,551113,758304,775847,399097,832954,20511,95651,552951,182803,237325,668437,1021510,784990,428600,735161,35252,371840,649862) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 686038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002883s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 686038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]