SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 174448 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 174448 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (153802,741098,816252,973359,304240,488470,293991,647695,78164,122122,482212,28845,385557,138794,31298,906080,48316,984740,680632,164137,596789,499141,805952,993580,1047496,856242,796225,5643,346793,784775,223131,426349,809078,362161,232693,295737,945624,393941,810460,996250,26600,836060,947521,150665,37763,612592,395819,479448,131301,408409,596488,739614,530519,709156,219872,513960,682332,248850,333502,527613) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 174448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 174448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]