SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398836 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398836 [ RunTime:0.001515s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017631,46486,806229,738709,960231,158969,142643,913700,787022,81765,294316,818146,325541,824393,1024692,771606,321960,963860,468115,58747,101174,25825,894069,626807,513940,36760,1036810,552118,288282,396265,365428,1012005,934770,624476,1001358,801492,250074,48820,981707,130539,122809,167803,462327,78877,883473,818081,390486,50584,281630,312821,516933,72641,811268,210046,621822,654080,1899,259233,902911,1029148) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398836 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398836 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]