SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004831s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 999513 LIMIT 1 [ RunTime:0.000565s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 999513 [ RunTime:0.004911s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (562328,619323,126057,440482,217582,166891,125134,790872,747208,552889,831423,272033,567100,782613,75174,354831,1035023,956740,490020,418398,202415,136423,1006409,68690,468312,335171,1010412,643835,370124,88953,651325,613955,1026798,238920,747243,218027,302163,926347,944883,28442,147285,697768,140441,363727,777887,685128,137577,65696,716291,687285,212579,487137,565026,1020324,629817,1031869,802143,957570,27598,61670) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 999513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000756s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 999513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]