SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 860438 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 860438 [ RunTime:0.001596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (433906,1025419,867827,1019036,191039,129837,504148,559540,183435,755754,681356,246803,34998,89929,457127,309792,518818,55883,314177,134041,512050,944250,11474,588460,496735,284307,714335,877734,783064,593877,384872,116675,46334,104669,1016025,143278,280445,602389,303708,1047200,371220,476944,792404,761657,237777,626674,498450,982191,146328,859554,93450,495939,281462,338229,836422,550925,796540,854572,46180,356364) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 860438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 860438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]