SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001460s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543221 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543221 [ RunTime:0.002496s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (929778,380142,36204,546761,810792,108554,84325,200555,24376,374323,873571,346060,1009657,1008733,881329,156977,909612,216899,127050,211341,1012616,522146,713779,118856,172072,719778,656822,884609,269997,703217,214971,664727,629113,619495,1016928,664770,649702,1033453,465125,577635,714813,347102,937455,616994,573524,265362,26953,52946,717683,966217,930920,804936,194916,909726,656410,76578,562092,470951,955567,824242) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543221 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543221 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000704s ]