SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401063 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401063 [ RunTime:0.002535s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (466513,312517,966757,636804,964115,740861,901074,50485,597328,607427,405606,812119,844055,514775,1048267,899121,984684,314035,673280,151599,108760,453474,323963,103017,171210,842487,513222,858781,353940,467858,181248,718986,17780,496475,1000722,813508,992668,86538,503555,674213,640684,69562,788722,860323,754536,71851,316613,370426,330082,922565,680436,133931,200231,334095,242765,555664,771111,633200,622381,826081) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]