SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 459820 LIMIT 1 [ RunTime:0.000480s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 459820 [ RunTime:0.001793s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (513184,920652,613491,201263,31335,210898,486128,602692,200352,928597,923538,62513,1042520,217775,661694,909581,212921,308757,272366,375000,606826,323374,381765,950626,448558,762337,778571,108192,606845,1013016,630165,827868,910552,97831,1046799,282530,386149,874328,63813,366025,624880,595111,969061,95134,467944,73918,644624,428553,943983,962734,892864,352962,47474,671305,326982,932548,336854,17412,661475,34555) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 459820 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 459820 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]