SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521428 LIMIT 1 [ RunTime:0.000684s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521428 [ RunTime:0.002945s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (653493,811302,297274,310771,542079,961271,113908,625335,969189,158983,414838,430598,853926,34257,191060,651425,182140,1024880,622795,74438,1027649,599209,888287,199334,97217,319958,485558,139149,16165,692491,353072,981574,742404,831746,901586,797470,847975,234871,112847,924402,232103,1020293,818275,315755,553331,265325,933624,1033697,441095,1041368,715540,505849,237988,694318,316710,1043448,676862,101661,812127,344819) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]