SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001721s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001645 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001645 [ RunTime:0.002215s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1021677,540987,905706,188571,44856,944804,97699,554184,833791,205885,299030,936418,522301,958278,711454,866991,103819,605113,192777,865071,874263,150935,280601,962447,353688,149335,364704,881331,219602,15823,711162,255191,952357,1042329,269121,312057,222200,800417,206798,675473,228570,226722,491679,35070,877573,166239,905547,9537,720643,9266,399645,418879,529016,940269,814769,818516,12889,183422,251264,8093) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001645 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001645 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002495s ]