SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010202 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010202 [ RunTime:0.002029s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (856021,714125,842457,36761,1023470,375615,29207,248108,456972,386899,642396,430082,783013,306983,149027,307924,942781,34313,614533,241000,896439,537880,452872,126253,430231,303094,891530,46924,842404,355845,501475,519949,32274,1003407,397267,172535,355172,68010,906833,563519,1044606,935218,806860,151470,395706,377455,294249,207803,786516,378823,735347,161526,39754,700401,399326,5935,497007,781757,354979,819032) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010202 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000770s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010202 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]