SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002090s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021924 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021924 [ RunTime:0.001889s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (299003,428641,109525,294446,369153,288935,6259,665300,654170,879337,772925,47564,926849,466826,193787,765126,1014504,266581,322948,637892,559935,837210,653669,928751,582771,344649,212362,338503,510016,947082,273740,664586,950197,383896,358649,479080,683080,392555,583091,751193,312445,950020,283918,301868,532090,959434,529363,267832,210246,1048252,301635,670423,800491,574869,270052,386967,294102,1006233,296411,200838) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021924 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021924 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001665s ]