SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336472 LIMIT 1 [ RunTime:0.000288s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336472 [ RunTime:0.002393s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (425428,366101,337733,1045446,826556,835797,583437,490204,251469,585438,294903,530688,976427,1006779,528138,535285,333573,838136,145292,412067,951702,472518,379318,262387,486027,663861,620194,460907,9280,1017222,105211,539443,307642,977163,431423,433449,624718,677155,358534,860027,289578,395093,622761,503326,390872,918776,930448,360994,459237,689042,555,369339,1481,491378,996301,88978,505860,118970,661320,535293) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336472 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336472 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]