SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 367517 LIMIT 1 [ RunTime:0.001016s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 367517 [ RunTime:0.001516s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447158,103455,688210,639782,174361,1008691,206744,107434,449828,29438,200801,363187,754083,310070,163382,700753,224208,269840,1015376,701749,140467,234311,532368,969192,868916,735223,849886,992057,255582,677363,438183,372464,798104,926612,524722,719270,394109,153496,554802,910636,619634,916361,852393,63824,479436,919660,808323,250041,269908,887531,571792,716959,453244,193296,655020,161100,1039682,897753,87528,912501) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 367517 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 367517 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]