SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002621 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002621 [ RunTime:0.001970s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (635217,991924,382314,338162,715252,43909,224320,471860,605834,982605,503907,756524,392440,315315,286655,289895,702013,469651,483996,171972,280109,780762,536216,406636,553922,387918,50924,828403,113199,360765,158411,578964,419780,923245,174463,199487,912520,576244,679021,927908,464203,822081,1035534,377490,988740,547780,860114,588915,201017,1047463,887208,891463,28742,156488,604631,890531,548835,451180,912328,900677) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002621 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002621 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]