SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541490 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541490 [ RunTime:0.002894s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1008289,1030748,1033914,722173,171497,351015,918334,710651,577991,960939,829904,117988,145111,513895,750386,421106,180082,499206,201487,265703,594165,1020263,865687,163075,157306,76133,824434,949635,196754,680337,608812,531761,107736,899695,1429,811849,317824,266741,779126,197606,642646,297492,46368,141190,67591,119659,975170,765567,61760,21553,744220,482854,216790,172466,827830,844972,677553,507055,61459,645232) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541490 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541490 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]