SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001393s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423410 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423410 [ RunTime:0.004033s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (832081,1039432,571191,729401,151911,961519,263832,979063,1006272,694067,101368,468937,414574,584630,930954,92393,322819,53884,1003793,714322,432299,686827,969647,360174,422458,680376,1013526,223419,1032055,967591,825542,867156,122017,425970,867198,733246,730688,608057,483454,361587,313007,185871,661339,88516,565070,119830,900667,1038468,589503,694122,661402,91748,657828,91712,119959,219127,558692,1010051,943181,29902) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001657s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001681s ]