SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562049 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562049 [ RunTime:0.001614s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (333468,748440,253300,186418,850498,1048554,1024902,743524,356121,1015681,571345,911804,891090,686028,428120,371354,860312,624374,986571,907021,652064,444836,11592,1005273,454738,423624,14116,208409,449141,76826,77236,50235,652577,475315,391118,660533,618324,333005,903916,310050,397364,201191,502781,731993,45694,122036,312403,991632,766691,932442,976044,102355,509732,67597,515236,471874,900205,844739,2236,610974) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562049 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562049 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]