SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200927 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200927 [ RunTime:0.001581s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101716,195551,772421,624450,555740,1016653,1041183,1018957,121221,853544,328607,932561,380467,793109,809614,940587,997763,992627,660240,617642,935187,152517,360905,440155,393277,190201,120650,59625,284818,724697,605812,1045190,82,802547,356774,280714,672614,52446,630890,751536,107619,656434,164461,943337,601926,648668,886296,469748,935223,157462,526160,114497,976197,440407,461529,712110,666420,237640,1039587,546778) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200927 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200927 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]