SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 99184 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 99184 [ RunTime:0.001751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (467817,294825,286274,558189,601698,177895,262938,248811,969777,126384,351628,698877,818553,778628,694788,101330,611214,1047729,394649,641751,557199,154168,45137,1041388,492960,621420,56753,904674,110566,859397,60410,1008612,270733,448349,547516,1030038,772163,257654,536942,731013,419302,565737,169340,238428,339454,662801,47644,366400,652094,479565,325426,791543,281324,929269,1038910,957126,344314,502140,334451,323075) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 99184 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 99184 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]