SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001399s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 375541 LIMIT 1 [ RunTime:0.000584s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 375541 [ RunTime:0.001953s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (691983,827157,93281,319867,284038,598343,687892,383773,613766,1021860,290228,260279,539270,203035,414759,467535,943129,612673,678108,1021192,472471,71436,297018,509359,477093,648493,451363,142589,782518,771296,1022588,990651,972595,899803,949240,446569,728454,263067,547921,538484,831182,78472,663022,5075,978150,9460,714437,1028516,781795,973809,312345,567944,713603,991256,76669,1023137,470821,104904,868546,117615) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 375541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 375541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000696s ]