SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040858 LIMIT 1 [ RunTime:0.000494s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040858 [ RunTime:0.003310s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (429620,447316,404194,285894,694743,962348,997607,340116,423147,930307,639477,965978,1027056,719878,224428,155888,607185,472856,418757,838300,50510,623948,738631,433535,742755,496156,272772,926909,757233,239479,467768,601472,331401,670098,860565,875024,470374,85669,73521,550928,272700,787343,246730,278905,308695,377938,925050,241141,512636,594241,191370,974083,6188,442663,9023,325795,1018211,267053,732855,417956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040858 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040858 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]