SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50623 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50623 [ RunTime:0.003484s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412168,474037,231974,958269,837128,129849,361755,624652,999902,822442,514308,1044443,95521,249941,979445,551505,132303,392057,90832,852293,1034000,879815,797148,189368,674597,205812,722192,866639,277943,651022,47587,581557,947575,880115,471951,226792,882906,302234,689219,155198,421948,389869,78242,519399,97923,17013,339700,425435,87045,369553,511816,346865,657005,225726,985065,117550,244979,877414,1008507,41105) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50623 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50623 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000816s ]