SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 569508 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 569508 [ RunTime:0.001600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (980325,401075,416567,171982,881003,996581,235250,803637,560267,381681,333630,13063,596472,365188,485420,947876,104741,688072,791197,856381,925405,448215,170732,645542,662616,685065,594190,508484,849954,809309,851217,816490,436968,723052,752943,266569,390019,602289,880964,394848,1025725,443021,257656,228837,390701,1035492,306835,486449,532444,494511,208723,971780,358920,154919,1037186,733776,1037683,1006124,55824,165135) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 569508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 569508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]