SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107528 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107528 [ RunTime:0.001994s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (290698,237987,1048656,656410,791644,811295,986411,511422,423187,348539,731321,680852,417507,753773,28451,276807,733272,1031019,743386,882653,891986,506645,229715,668145,664219,255402,945421,690515,72929,1024833,358261,540711,229678,589384,724187,849425,17614,37993,613269,38734,561657,109313,909811,778574,779265,124223,276576,507177,323325,488309,1047881,293882,700508,907707,407179,604295,1029446,480873,373808,554651) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]