SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532622 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532622 [ RunTime:0.003161s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013005,786371,472582,956827,1034981,38178,83372,518163,744480,851570,723144,148927,260444,249236,702954,738050,741032,717783,67482,497702,526858,46273,726996,729451,154029,4332,291003,264247,145733,30358,264911,425516,454666,875486,670060,618811,146641,838017,9897,535027,886143,13232,624756,657927,1009277,252327,36168,719969,953032,737734,691257,21376,927622,158037,812227,73181,959483,691241,328644,510412) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532622 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532622 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]