SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 143053 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 143053 [ RunTime:0.003937s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (469768,766181,681539,85568,374188,1020282,850049,652104,499950,41056,749069,362190,1032347,745736,298234,849514,953519,141584,22510,498439,397170,660362,518111,900365,792896,500240,830842,344468,628202,139647,682012,507148,447309,442708,780043,48818,695475,222862,520345,771379,382759,284067,367896,400521,441133,472518,913569,203766,890809,994357,1010146,228868,730114,127538,195246,147522,482733,804210,17468,324320) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 143053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 143053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]