SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002851s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 371614 LIMIT 1 [ RunTime:0.003845s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 371614 [ RunTime:0.005962s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (443817,554500,738475,276939,108684,167261,154156,23396,852192,2723,741672,651660,166710,37963,382914,221247,723771,227605,570171,924157,280666,826188,1020935,858059,1021299,496834,332156,238601,125852,525418,401366,876693,1032139,392139,1032512,802700,926191,62849,724890,12270,92981,368458,412381,879556,156971,1016351,129311,56515,674490,749573,860238,314649,212125,857049,340744,708159,304799,263496,706518,663079) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 371614 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000792s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 371614 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]