SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 14214 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 14214 [ RunTime:0.001644s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (98131,965897,63485,439847,358607,105128,98403,57219,859907,274915,56135,336326,570849,139046,372494,149164,151769,72250,700403,250627,324613,820194,777812,1016119,157167,243125,428116,481969,151549,293307,862949,685458,312294,434628,549078,382248,115087,932225,889571,433700,774535,412986,870481,327039,341089,667123,921430,898839,373239,720146,727724,373164,791447,641872,119713,609746,550104,528618,753635,735810) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 14214 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 14214 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002072s ]