SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429300 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429300 [ RunTime:0.006582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (77677,447863,1010786,834881,316847,569540,102386,183159,332601,435087,316944,798667,620087,842625,929045,350949,897403,806876,324859,570728,791702,877442,673802,43275,206502,839551,995614,43756,560757,169114,968203,552662,499105,893541,48774,416483,1006316,52747,498251,905414,132531,130282,1025569,236419,310722,718549,743318,37604,416099,367668,931325,922225,302236,1033800,546719,697653,866086,235687,991212,776193) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003914s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]