SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 985628 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 985628 [ RunTime:0.001664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1035751,384647,879056,343165,573536,93360,67619,969090,578919,560083,546170,677443,990447,859640,682409,2059,500872,599015,495004,683901,156519,60073,296751,576230,837965,380196,803239,52556,229478,517873,609589,135749,248266,532329,1005497,850,1033779,647136,86426,801752,1022006,346509,23035,267416,879328,697420,1021844,296796,149342,993059,171393,614125,389526,65378,546299,709641,862483,17952,768401,882273) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 985628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000810s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 985628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003277s ]