SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521896 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521896 [ RunTime:0.001559s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020220,786104,361324,1025462,436939,375501,35953,658187,666783,969762,712725,21089,115813,992172,920641,742048,697943,416997,594693,278608,951087,430891,783609,676001,704962,1045413,1018373,844081,733500,868531,490112,112074,324371,138319,650017,609947,926683,609379,902363,1037601,580416,572605,257261,968609,88121,143585,362512,579552,440975,69298,405971,229368,65479,947877,1011890,846810,177577,752925,325367,526332) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]