SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 585398 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 585398 [ RunTime:0.002103s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1018685,109361,1014125,1041305,1013949,450512,721182,527292,217022,994068,955515,643787,231872,415797,167602,1006148,781723,377663,213174,899232,867599,127405,364541,194168,350061,897574,997255,175177,657386,720056,278988,7225,343754,337031,427394,482265,34888,538829,653167,387366,6830,635693,955303,393669,519379,822279,340630,328611,771871,162402,575703,472374,542230,507270,892243,191360,483456,470088,909025,534561) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 585398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 585398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001435s ]