SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 47651 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 47651 [ RunTime:0.001492s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (513341,701790,240309,962871,58795,279123,317145,1000015,741778,470634,806229,160605,21627,632974,365601,370734,422893,656315,696621,511624,333993,443434,413106,650717,44634,395199,791373,127786,36369,361044,522084,205677,773193,974481,271809,535,750711,237641,103186,84084,987113,1032826,925750,458934,485866,19158,371836,826708,248168,712401,463523,243908,194952,816804,772447,19085,190053,527982,265454,441759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 47651 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 47651 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]