SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547753 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547753 [ RunTime:0.002062s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (919745,1017199,380295,316441,1045453,293351,836612,1028411,447038,142141,1046932,785466,97462,21750,520342,481338,594017,525777,283153,874527,449745,52921,340890,119958,665664,33306,299316,284671,753227,261234,140450,1045053,115536,448697,234583,500027,671096,703970,603218,664868,444258,796135,405654,131375,260946,832424,877266,275044,469306,224945,146719,52168,554457,61863,432917,105309,813568,854220,341586,83468) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547753 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547753 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]