SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415581 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415581 [ RunTime:0.001800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027107,638434,748740,671811,427669,95912,1027162,456139,379534,410162,94751,1030430,183130,754341,412915,540063,849155,970021,604415,580230,166506,327118,581224,854186,274956,675530,851629,983421,316414,646205,231109,134320,244804,977152,732069,586243,166403,725328,226478,464578,715481,381099,69101,225350,17478,878660,575436,309294,228364,684957,388396,222677,635675,709887,812725,121267,150766,827254,352110,680) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000561s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000659s ]