SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028036 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028036 [ RunTime:0.002071s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (857909,843606,635000,216873,421187,273309,197234,732075,491064,528450,930524,822773,721359,249941,362101,818430,719143,139847,236790,741954,242022,263902,875970,378307,662024,578709,281285,74934,715628,1004573,161702,950401,249610,199117,249068,1000037,571700,771763,442322,139824,669552,658428,2590,562282,1035077,205503,631981,547648,39400,500667,286784,137314,856250,562112,1026837,982510,243320,485577,520061,285463) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000399s ]