SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508091 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508091 [ RunTime:0.001763s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (320423,327124,186277,159819,287982,127179,1007287,126631,286556,293092,846541,959575,911660,143187,218138,298412,991825,736130,700601,305950,780114,417788,119380,57126,899459,617100,11204,682147,355443,982845,164993,659225,152378,105160,990612,555973,224581,82534,131406,283678,759689,751583,753699,273664,916693,696496,274039,699763,830788,996700,1024678,196596,123476,346072,337978,673052,959920,267323,443910,957275) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]