SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531926 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531926 [ RunTime:0.003576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111126,375541,594133,708053,57370,316897,1015598,925238,400834,738611,441656,1011143,759301,707577,754855,874053,610984,830901,414231,73060,852817,629905,109273,270308,180301,67938,247123,442955,135202,812091,36084,127389,734927,283375,630276,132612,469713,1020578,173384,205281,91400,228247,886085,238917,323695,922156,743029,537390,1029518,369342,824315,113229,773088,729676,203286,199529,294638,138255,278212,330773) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531926 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531926 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]