SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001598s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404360 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404360 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (773027,669142,723947,228878,68535,327101,576729,519484,763155,797663,795360,628551,843092,885744,951704,415757,914239,1014433,534761,137092,277175,905455,32934,646764,769343,344750,311863,692994,425013,490979,958073,171049,833135,851304,322220,920270,833325,94242,31614,26252,203646,86555,198449,887369,930313,462546,956676,55776,376529,1022341,1011406,1034782,203672,317358,621689,606135,151327,397381,831414,937928) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002156s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404360 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404360 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]