SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020427 LIMIT 1 [ RunTime:0.000472s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020427 [ RunTime:0.011503s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (768070,225837,614404,97988,620724,659206,41844,665034,70821,68308,502886,3137,11718,923834,219217,671773,103555,636152,968858,652244,195091,310554,901575,992642,519043,611487,884196,888460,1045791,484886,970506,988606,327075,150583,757338,789028,1041026,439429,1004566,34435,681151,1003093,808644,962401,272938,284350,131180,156418,53853,238308,981639,708704,500923,794593,806045,1033922,648133,664080,387817,476063) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020427 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000601s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020427 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001829s ]