SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 571004 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 571004 [ RunTime:0.001844s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201424,158601,420274,46812,120174,975030,714773,645696,165389,777323,98106,499940,260241,387525,716022,26880,353585,925711,75728,975607,558029,671248,498127,290201,506118,58238,789251,679302,575578,102672,86676,511942,586218,1024384,949686,891993,467906,782613,727915,978008,582137,983551,453297,336638,915833,473439,478491,290719,541204,544052,117148,704189,9127,167571,868719,871090,115319,710201,227057,183751) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002761s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 571004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 571004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]