SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467046 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467046 [ RunTime:0.003538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412516,7998,674391,421440,420931,4533,886952,867077,180361,793906,283267,465389,229148,312282,691507,519163,806821,680621,988445,673452,10742,399545,106401,891380,651863,849496,354570,138580,743594,746258,848766,684468,658261,570345,265102,18868,86203,946140,836812,918779,264486,464964,287490,277429,615607,1004007,951531,973966,697244,947522,487557,98477,329849,46952,800725,395874,838738,823081,600846,322348) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467046 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467046 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]