SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 920556 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 920556 [ RunTime:0.004158s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (918185,682075,99316,1006047,314085,456913,86198,844903,207468,37455,311866,327635,433523,178080,599374,440145,202770,559325,223161,458196,337878,615556,280537,258822,528065,656196,88551,253453,801912,1025169,250709,490023,730350,489296,86137,617981,287160,784780,1044125,779078,832687,840758,974786,274738,886977,802273,587530,423430,1017006,10490,688756,267636,615058,171198,598930,686980,199824,663682,416588,1024644) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 920556 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 920556 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]