SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 904870 LIMIT 1 [ RunTime:0.000281s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 904870 [ RunTime:0.001896s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (452099,493773,259533,620233,311508,830750,250518,294916,287810,603567,347257,528817,939913,1011025,739586,370033,746989,56439,727875,895436,1036388,843037,782099,132128,1006101,1029747,798322,859411,286711,672132,39978,34655,678752,224569,502636,637718,793222,131788,10524,234710,193858,990894,166931,117694,905024,890770,500505,354690,337091,399244,948639,670187,84957,274161,200499,931581,149826,1043061,531754,875260) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 904870 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 904870 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000462s ]