SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542940 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542940 [ RunTime:0.001730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (219635,30326,858522,445928,963519,489582,885027,65372,108003,816628,161301,357498,438522,952539,730211,65130,47667,540661,456607,281429,654611,118361,846740,138939,280489,446436,171074,215471,434707,1046971,446441,669471,737594,495594,852060,550533,1039704,320810,442276,150430,69812,67039,828077,1017676,37261,585490,440076,575858,18926,594524,861691,303672,305617,253932,15435,628905,114165,1015723,251191,99788) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]