SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42531 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42531 [ RunTime:0.001621s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (433714,901374,234755,952144,99052,520292,1002252,491560,735014,886616,258312,735097,1026306,876387,754799,711013,551031,185163,983543,937380,375625,636864,280580,81338,501572,7797,455003,654404,650438,897959,622733,791541,741777,645218,152190,264488,310967,908343,769464,1004035,440792,761940,66253,1025429,255041,830135,155753,403898,935033,176661,302677,359969,812155,862685,21834,148414,420001,536253,45659,719614) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42531 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42531 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000746s ]