SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411392 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411392 [ RunTime:0.002536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802535,162149,951271,386991,126874,1023515,626368,600963,210651,675259,676689,905430,86159,372782,483061,278129,762029,991439,259205,560969,439777,681603,781040,957367,153254,335927,879205,182554,109512,776864,731163,953839,1008076,869131,106910,692806,1048431,906935,451619,311794,236371,273447,294059,409843,361740,542491,87781,685182,972925,70618,634133,994504,322530,1026903,454356,982326,385119,269307,727592,504081) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411392 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000599s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411392 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]