SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542223 LIMIT 1 [ RunTime:0.005445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542223 [ RunTime:0.006013s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (553216,653469,754877,1019912,708611,666207,241112,303210,34693,354407,558574,356791,785086,1000981,798732,624951,168438,433158,990292,1018656,476811,299334,82163,21252,199912,616649,46580,597202,603476,371161,427834,1044436,139891,104019,251167,285583,39634,555252,390308,492167,731588,283014,29358,38359,16741,885718,147332,577167,243337,844494,983354,810396,533523,202966,498291,1020845,982739,929928,666789,363375) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002649s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542223 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002865s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542223 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]