SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005480 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005480 [ RunTime:0.001787s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (792800,207935,496147,188200,1029756,172331,670243,839347,80491,587027,77423,580442,977359,739201,408151,465513,525148,290869,788817,56768,856179,160849,468826,50186,371205,996338,793381,395221,373924,581765,1008906,653680,958674,967793,728452,389396,435689,448775,93447,735037,487213,652036,3369,981951,601886,319988,152417,582847,591190,816648,1020685,542542,947078,132553,187607,925210,419514,691561,544870,435895) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000395s ]